{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Main Sheet","Mixed Air Temp","Mixed Water Temp","Dates","Ductwork","Interpolation","Feet & Inches","Loads","Unit Conversion","Pipe","Motor","Percentage","Individual Percentage","Percent EA","GPM","Demo","Fan Law","Airflow","Pressurization","Louver","Message","Disclaimer","Electrical","Chiller","100 OA","Pipe Cost"],"not_rendered":{"charts":1,"images":54,"macros":1,"external_links":1,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main Sheet","index":0,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[25,1,25,7],[5,2,5,6],[5,9,5,12],[22,1,22,7],[23,1,23,7],[24,1,24,7]]}
[null,null,null,null,null,null,null,"ID: FREE"]
[null,null,null,null,"www.HVACnotebook.com",null,null,"v.7.11"]
[null,null,null,null,"                 QuickCalcs-HVAC (FREE Sample Version)"]
[null,null,null,null,"User Guide & Disclaimer"]
[]
[null,null,"Calculation Spreadsheets",null,null,null,null,null,null,"Simple User Interface"]
[null,null,"Feet & Inches   (Math)",null,"Mixed Air Temperature",null,"GPM Calculations",null,null,null,34,"Click On Any Yellow Cells And Enter (Replace With) Your Value"]
[]
[null,null,"Dates",null,"Mixed Water Temperature",null,"Water Volume Inside Pipe",null,null,null,{"$f":"K7/12","v":2.8333333333333335},"Cell With Auto-Calculated Value."]
[]
[null,null,"Percentage (Common)",null,"Ductwork Calculations",null,"Airflow Calculations",null,null,null,1234,"Cell With Auto-Calculated Final Answer."]
[]
[null,null,"Percentage (Individual)",null,"Louver Sizing",null,"Fan Motor HP",null,null,null,"DEMO","Calculation Only Available in Full Version."]
[]
[null,null,"Percentage (Engr./Arch.)",null,"Fan Laws",null,"Electrical: Ohm's Law"]
[]
[null,null,"Interpolation",null,"Pump Laws",null,"Piping Cost Estimate"]
[]
[null,null,"Unit Conversions",null,"100% Outside Air Unit",null,"Chiller (Electric)"]
[]
[null,null,"Cooling & Heating Loads"]
[]
[null,"This is a FREE Sample Version where some calculations have been disabled and sheets can not be printed."]
[null,"Get the Full Version of \"M1-QuickCalcs-HVAC.xlsm\" "]
[null,"We can create custom calculation spreadsheets for you."]
[null,"Visit www.HVACnotebook.com for more free products and information."]

{"sheet":"Mixed Air Temp","index":1,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[6,2,7,2],[8,2,9,2],[10,2,11,2],[3,2,3,6],[0,1,0,7]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,null,"Mixed Air Temperature"]
[]
[]
[null,null,"A","TA",72,"F","Temperature of  \"A\"",null,"`"]
[null,null,null,"CFMA",10000,"CFM","Airflow of \"A\""]
[null,null,"B","TB",50,"F","Temperature of  \"B\""]
[null,null,null,"CFMB",3000,"CFM","Airflow of \"B\""]
[null,null,"MixedA+B","TA+B =",{"$f":"E7+(E10/(E8+E10))*(E9-E7)","v":66.92307692307692},"F","Mixed Air Temperature"]
[null,null,null,"CFMA+B =",{"$f":"E8+E10","v":13000},"CFM","Mixed Airflow"]

{"sheet":"Mixed Water Temp","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,1,0,7],[3,2,3,6],[6,2,7,2],[8,2,9,2],[10,2,11,2]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,null,"Mixed Water Temperature"]
[]
[]
[null,null,"A","TA",45,"F","Temperature of  \"A\"",null,"`"]
[null,null,null,"GPMA",500,"GPM","Water Flow of \"A\""]
[null,null,"B","TB",55,"F","Temperature of  \"B\""]
[null,null,null,"GPMB",200,"GPM","Water Flow of \"B\""]
[null,null,"MixedA+B","TA+B =",{"$f":"E7+(E10/(E8+E10))*(E9-E7)","v":47.857142857142854},"F","Mixed Water Temperature"]
[null,null,null,"GPMA+B =",{"$f":"E8+E10","v":700},"GPM","Mixed Water Flow"]

{"sheet":"Dates","index":3,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[[11,1,11,4],[11,7,11,8],[1,1,1,7],[3,1,3,4],[3,6,3,8]]}
[]
[null,"Please read the User Guide and Disclaimer prior to use.",null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,"TIME ELAPSED (Years, Months and Days)",null,null,null,null,"# OF WEEKS AFTER"]
[null,null,"Start Date","End Date","Time Elapsed",null,"Date","# Weeks After","New Date"]
[null,"My Age","1978-05-21","2013-11-28",{"$f":"IF(D6,IF(AND(DATEDIF(C6,D6,\"y\") <=0, DATEDIF(C6,D6,\"ym\") <=0), DATEDIF(C6,D6,\"md\") & \" day(s)\",\nIF(DATEDIF(C6,D6,\"y\")<=0, DATEDIF(C6,D6,\"ym\") & \" month(s) and \"& DATEDIF(C6,D6,\"md\") & \" day(s)\",\nDATEDIF(C6,D6,\"y\") & \" year(s), \" & DATEDIF(C6,D6,\"ym\") & \" month(s) and \"& DATEDIF(C6,D6,\"md\") & \" day(s)\")),\"\")","v":"35 year(s), 6 month(s) and 7 day(s)"},null,"2013-11-28",3,{"$f":"IF(H6,DATE(YEAR(G6),MONTH(G6),DAY(G6)+H6*7),\"\")","v":"2013-12-19"}]
[null,"Career with Company","2013-01-05","2013-11-28",{"$f":"IF(D7,IF(AND(DATEDIF(C7,D7,\"y\") <=0, DATEDIF(C7,D7,\"ym\") <=0), DATEDIF(C7,D7,\"md\") & \" day(s)\",\nIF(DATEDIF(C7,D7,\"y\")<=0, DATEDIF(C7,D7,\"ym\") & \" month(s) and \"& DATEDIF(C7,D7,\"md\") & \" day(s)\",\nDATEDIF(C7,D7,\"y\") & \" year(s), \" & DATEDIF(C7,D7,\"ym\") & \" month(s) and \"& DATEDIF(C7,D7,\"md\") & \" day(s)\")),\"\")","v":"10 month(s) and 23 day(s)"},null,"2013-11-29",4,"2013-12-27"]
[null,"Trip","2009-05-22","2015-09-25","6 year(s), 4 month(s) and 3 day(s)",null,"2013-11-30",5,"2014-01-04"]
[null,null,null,null,"",null,"2013-12-01",11,{"$f":"IF(H9,DATE(YEAR(G9),MONTH(G9),DAY(G9)+H9*7),\"\")","v":"2014-02-16"}]
[null,null,null,null,"",null,"2013-12-02",null,{"$f":"IF(H10,DATE(YEAR(G10),MONTH(G10),DAY(G10)+H10*7),\"\")","v":""}]
[]
[null,"TIME ELAPSED (Days)",null,null,null,null,null,"DATE OF THE WEEK"]
[null,null,"Start Date","End Date","Time Elapsed",null,null,"Date","Date of the Week"]
[null,"Last Trip","2013-05-01","2013-11-28",{"$f":"IF(D14,DATEDIF(C14,D14,\"d\") & \" Days\", \"\")","v":"211 Days"},null,null,"1975-10-11",{"$f":"IF(H14,TEXT(H14,\"dddd\"), \"\")","v":"Saturday"}]
[null,null,"2013-01-05","2013-11-28","327 Days",null,null,"2013-11-28","Thursday"]
[null,null,null,null,{"$f":"IF(D16,DATEDIF(C16,D16,\"d\") & \" Days\", \"\")","v":""},null,null,null,{"$f":"IF(H16,TEXT(H16,\"dddd\"), \"\")","v":""}]
[null,null,null,null,{"$f":"IF(D17,DATEDIF(C17,D17,\"d\") & \" Days\", \"\")","v":""},null,null,null,{"$f":"IF(H17,TEXT(H17,\"dddd\"), \"\")","v":""}]

{"sheet":"Ductwork","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,5,1,7],[0,5,0,7],[22,0,22,13],[21,0,21,13],[12,1,12,3],[3,9,3,12],[3,1,3,3],[12,5,12,7],[3,5,3,7],[12,9,12,12],[20,0,20,13],[19,11,19,12],[8,11,8,12],[9,11,9,12],[10,11,10,12]]}
[null,null,null,null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,"DUCTWORK CALCULATIONS",null,null,null,"Return To Main Sheet"]
[]
[null,"Duct Airflow Calculation",null,null,null,"Circular Duct Air Velocity Calculation",null,null,null,"Equivalent Round Duct Size from Rect. Duct"]
[]
[]
[null,"Duct Cross Section: Width (W)",34,"Inches"]
[null,"Duct Cross Section: Height (H)",24,"Inches"]
[null,"Area =",{"$f":"C7*C8/144","v":5.666666666666667},"Sq. Ft",null,"Duct Diameter (Dia.) =",26,"Inches",null,"Duct Cross Section: Width (W)",30,"Inches"]
[null,"Air Velocity ",1500,"FPM",null,"Airflow (CFM)",10000,"CFM",null,"Duct Cross Section: Height (H)",24,"Inches"]
[null,"Airflow =",{"$f":"C9*C10","v":8500},"CFM",null,"Air Velocity =",{"$f":"G10/((3.14*(G9/2)*(G9/2))/144)","v":2713.6019296724835},"FPM",null,"Equilvalent Diameter (Dia.) =",{"$f":"1.3*(((K9*K10)^0.625)/(((K9+K10)^0.25)))","v":29.287191208837108},"Inches"]
[]
[null,"Duct Velocity Pressure",null,null,null,"Rectangular Duct Air Velocity Calculation",null,null,null,"Duct Surface Area"]
[]
[]
[null,null,null,null,null,"Duct Cross Section: Width (W)","DEMO","Inches",null,null,"Inches",null,"Feet"]
[null,"Air Velocity",1500,"FPM",null,"Duct Cross Section: Height (H)","DEMO","Inches",null,"Duct Cross Section: Width (W)",20,"=",{"$f":"K17/12","v":1.6666666666666667}]
[null,"Velocity Pressure =",{"$f":"(G11/4005)^2","v":0.459078800233929},"psi",null,"Area =","DEMO","Sq. Ft",null,"Duct Cross Section: Height (H)",24,"=",{"$f":"K18/12","v":2}]
[null,null,null,null,null,"Airflow","DEMO","CFM",null,"Duct Length",96,"=",{"$f":"K19/12","v":8}]
[null,null,null,null,null,"Air Velocity = ","DEMO","FPM",null,"Total Surface Area = ",{"$f":"M17*M19*2+M18*M19*2","v":58.666666666666671},"Sq. Ft"]
["Get the Full Version of \"QuickCalcs-HVAC.xlsm\" to use all features."]
["The above calculations are also available in CalcSheet format: \"D2 - Ductwork Surface Area, Weight and Cost Estimates.xlsx\""]
["Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Interpolation","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,1,0,7],[4,2,4,6],[13,2,13,3],[8,2,8,3],[8,5,8,6],[13,5,13,6],[1,5,1,6]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,"Return To Main Sheet"]
[]
[]
[null,null,"INTERPOLATION"]
[]
[]
[]
[null,null,"(1)",null,null,"(100th)"]
[null,null,1,10,null,12,10.7]
[null,null,{"$f":"C12-(((D12-D11)/(D12-D10))*(C12-C10))","v":2},20,null,{"$f":"F12-(((G12-G11)/(G12-G10))*(F12-F10))","v":19.96},20.65]
[null,null,3,30,null,28,30.7]
[]
[null,null,"(10th)",null,null,"(1,000th)"]
[null,null,10,10.5,null,1E-3,0.06]
[null,null,{"$f":"C17-(((D17-D16)/(D17-D15))*(C17-C15))","v":19.405940594059405},20,null,{"$f":"F17-(((G17-G16)/(G17-G15))*(F17-F15))","v":2.0000000000000009E-3},7.0000000000000007E-2]
[null,null,30,30.7,null,3.0000000000000001E-3,0.08]

{"sheet":"Feet & Inches","index":6,"n_rows":19,"n_cols":31,"rows_kept":19,"cut":false,"hidden":true,"merged":[[18,18,18,19],[12,25,12,31],[18,26,18,27],[3,8,3,15],[4,8,4,15],[4,25,4,31],[4,17,4,23],[18,9,18,10],[12,17,12,23],[13,17,13,23],[15,18,15,19],[16,18,16,19],[17,18,17,19],[13,25,13,31],[1,25,1,29],[9,18,9,19],[3,1,3,6],[4,1,4,6],[3,17,3,23],[3,25,3,31],[9,26,9,27]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEET & INCHES  (MATH)",null,null,null,null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,"Addition",null,null,null,null,null,null,"Addition",null,null,null,null,null,null,null,null,"Subtraction",null,null,null,null,null,null,null,"Multiplication","Mulitplication"]
[null,"(By Entering Inches Only)",null,null,null,null,null,null,"(By Entering Feet & Inches)",null,null,null,null,null,null,null,null,"(By Entering Feet & Inches)",null,null,null,null,null,null,null,"(Area)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feet","Inches",null,null,null,null,null,null,"Feet","Inches"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,{"$f":"IF(T8=\"\", \"\",S8*12+T8)","v":42},"=",{"$f":"IF(U8=\"\", \"\", IF(U8<12,U8&\"\"\"\", INT(U8/12) &\"' - \"&MOD(U8,12)&\"\"\"\"))","v":"3' - 6\""},null,null,null,6,6,{"$f":"IF(AB8=\"\", \"\",AA8*12+AB8)","v":78},"=",{"$f":"IF(AC8=\"\", \"\", IF(AC8<12,AC8&\"\"\"\", INT(AC8/12) &\"' - \"&MOD(AC8,12)&\"\"\"\"))","v":"6' - 6\""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,{"$f":"IF(T9=\"\", \"\",S9*12+T9)","v":30},"=",{"$f":"IF(U9=\"\", \"\", IF(U9<12,U9&\"\"\"\", INT(U9/12) &\"' - \"&MOD(U9,12)&\"\"\"\"))","v":"2' - 6\""},null,null,null,5,6,{"$f":"IF(AB9=\"\", \"\",AA9*12+AB9)","v":66},"=","5' - 6\""]
[null,null,"Inches",null,null,null,null,null,null,"Feet","Inches",null,null,null,null,null,null,null,"Result",null,{"$f":"U8-U9","v":12},"=",{"$f":"IF(U10=\"\", \"\", IF(U10<12,U10&\"\"\"\", INT(U10/12) &\"' - \"&MOD(U10,12)&\"\"\"\"))","v":"1' - 0\""},null,null,null,"Area (Sq. Ft.)",null,{"$f":"AC8*AC9","v":5148},"=",{"$f":"AC10/144","v":35.75}]
[null,null,25,{"$f":"C11","v":25},"=",{"$f":"IF(C11=\"\", \"\", IF(C11<12,C11&\"\"\"\", INT(C11/12) &\"' - \"&MOD(C11,12)&\"\"\"\"))","v":"2' - 1\""},null,null,null,25,5,{"$f":"IF(AND(J11=\"\",K11=\"\"), \"\",J11*12+K11)","v":305},"=",{"$f":"IF(L11=\"\", \"\", IF(L11<12,L11&\"\"\"\", INT(L11/12) &\"' - \"&MOD(L11,12)&\"\"\"\"))","v":"25' - 5\""}]
[null,null,36,{"$f":"C12","v":36},"=","3' - 0\"",null,null,null,6,56,128,"=","10' - 8\""]
[null,null,21,{"$f":"C13","v":21},"=",{"$f":"IF(C13=\"\", \"\", IF(C13<12,C13&\"\"\"\", INT(C13/12) &\"' - \"&MOD(C13,12)&\"\"\"\"))","v":"1' - 9\""},null,null,null,36,5,437,"=","36' - 5\"",null,null,null,"Subtraction",null,null,null,null,null,null,null,"Multiplication","Mulitplication"]
[null,null,null,0,"=","",null,null,null,5,1,61,"=","5' - 1\"",null,null,null,"(By Entering Inches Only)",null,null,null,null,null,null,null,"(Volume)","Mulitplication"]
[null,null,null,0,"=","",null,null,null,6,5,77,"=","6' - 5\"",null,null,null,null,null,null,null,null,null,null,null,null,"Feet","Inches"]
[null,null,null,0,"=","",null,null,null,null,55,55,"=","4' - 7\"",null,null,null,null,"Inches",null,null,null,null,null,null,null,"DEMO","DEMO",null,"="]
[null,null,null,0,"=","",null,null,null,null,null,"","=","",null,null,null,null,"DEMO",null,{"$f":"IF(T17=\"\", \"\",S17*12+T17)","v":""},"=",null,null,null,null,"DEMO","DEMO",null,"="]
[null,null,null,0,"=","",null,null,null,null,null,"","=","",null,null,null,null,"DEMO",null,{"$f":"IF(T18=\"\", \"\",S18*12+T18)","v":""},"=",null,null,null,null,"DEMO","DEMO",null,"="]
[null,null,"Total",{"$f":"SUM(D11:D18)","v":82},"=",{"$f":"IF(D19=\"\", \"\", IF(D19<12,D19&\"\"\"\", INT(D19/12) &\"' - \"&MOD(D19,12)&\"\"\"\"))","v":"6' - 10\""},null,null,null,"Total",null,{"$f":"SUM(L11:L18)","v":1063},"=",{"$f":"IF(L19=\"\", \"\", IF(L19<12,L19&\"\"\"\", INT(L19/12) &\"' - \"&MOD(L19,12)&\"\"\"\"))","v":"88' - 7\""},null,null,null,null,"Result",null,{"$f":"U17-U18","v":{"$error":"#VALUE!"}},"=","DEMO",null,null,null,"Volume (Cu. Ft.)",null,null,"=","DEMO"]

{"sheet":"Loads","index":7,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,2,0,4],[15,1,15,6],[16,1,16,6],[4,2,4,4],[9,2,9,4]]}
[null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,"Return To Main Sheet"]
[null,null,"COOLING AND HEAT LOAD ROUGH ESTIMATES"]
[]
[null,null,"COOLING LOAD ESTIMATE"]
[null,null,"Space Area",4500,"Sq.Ft./Ton"]
[null,null,"Cooling Load Estimate (Sq.Ft. per Ton)",350,"Sq.Ft./Ton"]
[null,null,"Cooling Load = ",{"$f":"D6/D7","v":12.857142857142858},"Tons"]
[]
[null,null,"HEATING LOAD ESTIMATE"]
[null,null,"Space Area",4500,"Sq.Ft."]
[null,null,"Heating Load Estimate (Btuh per Sq.Ft.)",40,"Btuh/Sq.Ft."]
[null,null,"Heating Load = ",{"$f":"D11*D12","v":180000},"Btuh "]
[null,null,"Heating Load =",{"$f":"D13/1000","v":180},"MBH"]
[]
[null,"The above calculations are also available in CalcSheet format: \"L1 - Cooling and Heating Load Rough Estimates.xlsx\""]
[null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Unit Conversion","index":8,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":true,"merged":[[13,2,14,2],[1,7,1,9],[3,8,3,9],[4,1,11,1],[35,1,46,1],[26,1,33,1],[13,1,24,1],[15,2,16,2],[17,2,18,2],[23,2,24,2],[32,2,33,2],[30,2,31,2],[35,2,36,2],[0,3,0,5],[45,2,46,2],[43,2,44,2],[41,2,42,2],[39,2,40,2],[37,2,38,2],[1,3,1,5],[3,5,3,6],[28,2,29,2],[26,2,27,2],[19,2,20,2],[4,2,5,2],[6,2,7,2],[8,2,9,2],[21,2,22,2],[10,2,11,2],[48,1,63,1],[62,2,63,2],[60,2,61,2],[54,2,55,2],[52,2,53,2],[56,2,57,2],[58,2,59,2],[50,2,51,2],[48,2,49,2],[79,2,79,9],[65,1,76,1],[67,2,68,2],[65,2,66,2],[69,2,70,2],[71,2,72,2],[73,2,74,2],[75,2,76,2],[78,2,78,9]]}
[null,null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,"UNIT CONVERSIONS",null,null,null,"Return To Main Sheet"]
[]
[null,null,"Units","Conversion Basis",null,"Enter Value",null,null,"Result"]
[null,"Temperatures","Celsius <=> Fahrenheit"," Celsius = (5/9) x (Fahrenheit - 32)",null,180,"Fahrenheit","=",{"$f":"(5/9)*(F5-32)","v":82.222222222222229},"Celsius"]
[null,null,null,"Fahrenheit = (9/5) x Celsius + 32",null,13,"Celsius","=",{"$f":"(9/5)*F6+32","v":55.400000000000006},"Fahrenheit"]
[null,null,"Celsius <=> Kevin","Celsius = Kevin - 273.15",null,300,"Kevin","=",{"$f":"F7-273.15","v":26.850000000000023},"Celsius"]
[null,null,null,"Kevin = Celsius + 273.15",null,25,"Celsius","=",{"$f":"F8+273.15","v":298.14999999999998},"Kevin"]
[null,null,"Fahrenheit <=> Kevin","Fahrenheit = (9/5) x (Kevin - 273.15) + 32",null,290,"Kevin","=",{"$f":"(9/5)*(F9-273.15)+32","v":62.330000000000041},"Fahrenheit"]
[null,null,null,"Kevin = (Fahrenheit - 32) * (5/9) + 273.15",null,62.33,"Fahrenheit","=",{"$f":"(F10-32)*(5/9)+273.15","v":290},"Kevin"]
[null,null,"Rankine <=> Kevin","Rankine = (9/5) x Kevin",null,20,"Kevin","=",{"$f":"(9/5)*F11","v":36},"Rankine"]
[null,null,null,"Kevin = (5/9) x Rankine",null,36,"Rankine","=",{"$f":"F12*(5/9)","v":20},"Kevin"]
[]
[null,"Distance","inch <=> cm","1 inch = 2.54 cm",null,1,"inches","=",{"$f":"F14*2.54","v":2.54},"cm"]
[null,null,null,"cm = inches / 2.54",null,1,"cm","=",{"$f":"F15/2.54","v":0.39370078740157477},"inches"]
[null,null,"inch <=> mm","1 inch = 25.4 mm",null,1,"inches","=",{"$f":"F16*25.4","v":25.4},"mm"]
[null,null,null,"mm = inches / 25.4",null,1,"mm","=",{"$f":"F17/25.4","v":3.937007874015748E-2},"inches"]
[null,null,"feet <=> yard","1 yard = 3 feet",null,1,"yard","=",{"$f":"F18*3","v":3},"feet"]
[null,null,null,"feet = yard / 3",null,1,"feet","=",{"$f":"F19/3","v":0.33333333333333331},"yard"]
[null,null,"feet <=> meter","1 foot = 0.3048 meter",null,1,"feet","=",{"$f":"F20*0.3048","v":0.30480000000000002},"meter"]
[null,null,null,"1 meter = 3.28 feet",null,1,"meter","=",{"$f":"F21/0.3048","v":3.280839895013123},"feet"]
[null,null,"mile <=> feet","1 mile = 5,280 feet",null,1,"mile","=",{"$f":"F22*5280","v":5280},"feet"]
[null,null,null,"feet = miles / 5,280",null,5280,"feet","=",{"$f":"F23/5280","v":1},"mile"]
[null,null,"mile <=> yard","1 mile = 1,760 yards",null,1,"mile","=",{"$f":"F24*1760","v":1760},"yards"]
[null,null,null,"yards = miles / 1,760",null,1760,"yards","=",{"$f":"F25/1760","v":1},"mile"]
[]
[null,"Area","sq. ft. <=> sq. in.","1 sq. ft. = 144 sq. in.",null,1,"sq. ft.","=",{"$f":"F27*144","v":144},"sq. in."]
[null,null,null,"sq. in. = sq. ft / 144",null,1,"sq. in.","=",{"$f":"F28/144","v":6.9444444444444441E-3},"sq. ft."]
[null,null,"sq. ft. <=> sq. meter","1 sq. ft. = 0.0929 sq. meters",null,1,"sq. ft.","=",{"$f":"F29*0.0929","v":9.2899999999999996E-2},"sq. meters"]
[null,null,null,"1 sq. meter = 10.76 sq. ft.",null,1,"sq. meters","=",{"$f":"F30/0.0929","v":10.764262648008613},"sq. ft."]
[null,null,"sq. ft. <=> sq. cm","1 sq. ft. = 929 sq. cm",null,1,"sq. ft.","=",{"$f":"F31*929","v":929},"sq. cm"]
[null,null,null,"sq. cm = sq. ft. / 929",null,1,"sq. cm","=",{"$f":"F32/929","v":1.076426264800861E-3},"sq. ft."]
[null,null,"sq. ft. <=> sq. yards","1 sq. ft. = 0.1111 sq. yards",null,1,"sq. ft","=",{"$f":"F33*0.1111","v":0.1111},"sq. yards"]
[null,null,null,"1 sq. yard = 9 sq. ft.",null,1,"sq. yards","=",{"$f":"F34/0.1111","v":9.0009000900090008},"sq. ft."]
[]
[null,"Veolocity","fpm <=> mph","1 ft/min = 0.0114 mph",null,1,"ft/min","=",{"$f":"F36*0.0114","v":1.14E-2},"mph"]
[null,null,null,"1 mph = 87.7 fpm",null,1,"mph","=",{"$f":"F37/0.0114","v":87.719298245614027},"ft/min"]
[null,null,"mph <=> fps","1 mph = 1.467 ft/sec",null,1,"mph","=",{"$f":"F38*1.467","v":1.4670000000000001},"ft/sec"]
[null,null,null,"1 fps = 0.682 mph",null,1,"ft/sec","=",{"$f":"F39/1.467","v":0.68166325835037489},"mph"]
[null,null,"mps <=> mph","1 meter/sec = 2.237 mph",null,1,"meter/sec","=",{"$f":"F40*2.237","v":2.2370000000000001},"mph"]
[null,null,null,"1 mph = 0.447 meter/sec",null,1,"mph","=",{"$f":"F41/2.237","v":0.44702726866338843},"meter/sec"]
[null,null,"fps <=> m/s","1 ft/s = 0.3048 m/s",null,1,"ft/s","=",{"$f":"F42*0.3048","v":0.30480000000000002},"m/s"]
[null,null,null,"1 m/s = 3.2808 ft/s",null,1,"m/s","=",{"$f":"F43/0.3048","v":3.280839895013123},"ft/s"]
[null,null,"km/hr <=> m/s","1 km/hr = 0.2778 m/s",null,1,"km/hr","=",{"$f":"F44*0.2778","v":0.27779999999999999},"m/s"]
[null,null,null,"1 m/s = 3.5997 km/hr",null,1,"m/s","=",{"$f":"F45/0.2778","v":3.599712023038157},"km/hr"]
[null,null,"mps <=> fpm","1 meter/sec = 196.85 ft/min",null,1,"meter/sec","=",{"$f":"F46*196.85","v":196.85},"ft/min"]
[null,null,null,"fpm = meter/sec / 196.85",null,1,"ft/min","=",{"$f":"F47/196.85","v":5.0800101600203202E-3},"meter/sec"]
[]
[null,"Pressure","atm <=> psia","1 atm = 14.7 psia",null,1,"atm","=",{"$f":"F49*14.7","v":14.7},"psia"]
[null,null,null,"psia = atm / 14.7",null,1,"psia","=",{"$f":"F50/14.7","v":6.8027210884353748E-2},"atm"]
[null,null,"atm <=> psf","1 atm = 2,116.2 lb/ft2",null,1,"atm","=",{"$f":"F51*2116.2","v":2116.1999999999998},"lb/ft2"]
[null,null,null,"lb/ft = atm / 2,116.2",null,1,"lb/ft2","=",{"$f":"F52/2116.2","v":4.7254512805972975E-4},"atm"]
[null,null,"atm <=> in. Hg","1 atm = 29.92 in. Hg",null,1,"atm","=",{"$f":"F53*29.92","v":29.92},"in. Hg"]
[null,null,null,"in. Hg = atm / 29.92",null,1,"in. Hg","=",{"$f":"F54/29.92","v":3.3422459893048123E-2},"atm"]
[null,null,"in. water <=> in. mercury","1 in. water = 0.0739 in mercury",null,1,"in. water","=",{"$f":"F55*0.0739","v":7.3899999999999993E-2},"in. mercury"]
[null,null,null,"1 in. mercury = 13.53 in. water",null,1,"in. mercury","=",{"$f":"F56/0.0739","v":13.531799729364007},"in. water"]
[null,null,"in. Hg <=> in. water","1 in. Hg = 12.8 in water",null,1,"in. Hg","=",{"$f":"F57*12.8","v":12.8},"in. water"]
[null,null,null,"1 in. water = 0.0781 in. Hg",null,1,"in. water","=",{"$f":"F58/12.8","v":7.8125E-2},"in. Hg"]
[null,null,"ft. H2O <=> psi","1 ft.H2O = 0.4335 psi",null,1,"ft. H20","=",{"$f":"F59*0.4335","v":0.4335},"psi"]
[null,null,null,"1 psi = 2.31 ft. H20",null,1,"psi","=",{"$f":"F60/0.4335","v":2.306805074971165},"ft. H20"]
[null,null,"ft. H2O <=> psf","1 ft.H2O = 62.43 lbs./sq.ft.",null,1,"ft. H20","=",{"$f":"F61*62.43","v":62.43},"lbs/sq.ft"]
[null,null,null,"psf = ft. H20 / 62.43",null,1,"lbs/sq.ft","=",{"$f":"F62/62.43","v":1.6017940092904054E-2},"ft. H20"]
[null,null,"mm Hg <=> psi","1 mm Hg = 0.01934 lb/in2",null,1,"mm Hg","=",{"$f":"F63*0.01934","v":1.934E-2},"lb/in2"]
[null,null,null,"1 lb/in2 = 51.71 mm Hg",null,1,"lb/in2","=",{"$f":"F64/0.01934","v":51.706308169596689},"mm Hg"]
[]
[null,"Time","day <=> hours","1 day = 24 hours",null,1,"day","=",{"$f":"F66*24","v":24},"hours"]
[null,null,null,"hours = days / 24",null,24,"hours","=",{"$f":"F67/24","v":1},"day"]
[null,null,"day <=> minutes","1 day = 1,440 minutes",null,1,"day","=",{"$f":"F68*1440","v":1440},"minutes"]
[null,null,null,"minutes = days / 1,440",null,1,"minutes","=",{"$f":"F69/1440","v":6.9444444444444447E-4},"day"]
[null,null,"hour <=> minutes","1 hour = 60 minutes",null,1,"hour","=",{"$f":"F70*60","v":60},"minutes"]
[null,null,null,"minutes = hours / 60",null,1,"minutes","=",{"$f":"F71/60","v":1.6666666666666666E-2},"hour"]
[null,null,"minutes <=> seconds","1 minute = 60 seconds",null,1,"minutes","=",{"$f":"F72*60","v":60},"seconds"]
[null,null,null,"seconds = minutes / 60",null,1,"seconds","=",{"$f":"F73/60","v":1.6666666666666666E-2},"minutes"]
[null,null,"year <=> month","1 year = 12 months",null,1,"year","=",{"$f":"F74*12","v":12},"months"]
[null,null,null,"months = years / 12",null,1,"months","=",{"$f":"F75/12","v":8.3333333333333329E-2},"years"]
[null,null,"year <=> weeks","1 year = 52 weeks",null,1,"year","=",{"$f":"F76*52","v":52},"weeks"]
[null,null,null,"weeks = years / 52",null,52,"weeks","=",{"$f":"F77/52","v":1},"years"]
[]
[null,null,"The above calculations are also available in CalcSheet format: \"M5 - Unit Conversions.xlsx\""]
[null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Pipe","index":9,"n_rows":22,"n_cols":22,"rows_kept":22,"cut":false,"hidden":true,"merged":[[16,0,16,6],[4,1,4,5],[14,0,14,6],[15,0,15,6],[0,1,0,5],[13,0,13,6]]}
[null,"      Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,"Return To Main Sheet"]
[]
[]
[null,"Water Volume Inside Pipe"]
[null,"Segment","Pipe Diameter (Inches)","Pipe Length\n(Feet)","Water Inside Pipe (Gallons)","Remarks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/4\"",0.25]
[null,"A-B","1/4\"",50,{"$f":"IF(D7=\"\",\"\",IF(ISERROR(0.0034*(VLOOKUP(C7,$U$6:$V$22,2,FALSE)^2)*D7*12), \"\", 0.0034*(VLOOKUP(C7,$U$6:$V$22,2,FALSE)^2)*D7*12))","v":0.1275},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/8\"",0.375]
[null,"B-C","5\"",10,{"$f":"IF(D8=\"\",\"\",IF(ISERROR(0.0034*(VLOOKUP(C8,$U$6:$V$22,2,FALSE)^2)*D8*12), \"\", 0.0034*(VLOOKUP(C8,$U$6:$V$22,2,FALSE)^2)*D8*12))","v":10.199999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2\"",0.5]
[null,"C-D","1\"",1,4.0799999999999996E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3/4\"",0.75]
[null,"D-E","6\"",10,14.687999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1\"",1]
[null,null,null,"Total Volume = ",{"$f":"SUM(E7:E10)","v":25.0563},"Gallons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/4\"",1.25]
[null,null,null,"Allowance/Safety:",0.15,"Percent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-1/2\"",1.5]
[null,null,null,"Total Water Inside Piping with Safety = ",{"$f":"E11+E11*E12","v":28.814745000000002},"Gallons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2\"",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3\"",3]
["The above calculations are available in CalcSheet format: \"P2 - Water Volume Inside Piping Estimate.xlsx\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",4]
["Contact Us For More Information.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5\"",5]
[" Email: hvacnotebook@yahoo.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6\"",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10\"",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12\"",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14\"",14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16\"",16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18\"",18]

{"sheet":"Motor","index":10,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":true,"merged":[[3,3,3,5],[9,3,9,5],[0,2,0,6]]}
[null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,null,null,"Fan Motor - HP"]
[]
[]
[]
[]
[]
[null,null,null,"Fan Motor HP"]
[null,null,null,"Airflow",10000,"CFM"]
[null,null,null,"Static Pressure",2.4,"inches"]
[null,null,null,"Specific Gravity",1]
[null,null,null,"Fan Efficiency",0.6,"Percent"]
[null,null,null,"Brake HP = ",{"$f":"(E11*E12*E13)/(6356*E14)","v":6.2932662051604789},"BHP"]
[null,null,null,"Motor/Drive Effriciency",0.85]
[null,null,null,"Motor HP = ",{"$f":"E15/E16","v":7.4038425943064459},"HP"]
[]
[]
[null,null,null,null,"The above calculations are also available in CalcSheet format: \"EQ1 - Fan Motor HP Calculation.xlsx\""]
[null,null,null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Percentage","index":11,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[23,1,23,2],[27,1,27,2],[29,1,29,2],[33,1,33,2],[1,10,1,11],[21,7,21,8],[3,10,3,11],[10,10,10,11],[13,10,13,11],[20,10,20,11],[3,7,3,8],[10,7,10,8],[11,7,11,8],[13,7,13,8],[20,7,20,8],[0,4,0,9],[3,1,3,2],[10,1,10,2],[13,1,13,2],[20,1,20,2],[3,4,3,5],[10,4,10,5],[13,4,13,5],[20,4,20,5]]}
[null,null,null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"PERCENTAGE",null,null,null,"Return To Main Sheet"]
[]
[null,"Percentage Change",null,null,"Part of Total Percentage (1)",null,null,"Add A Percentage To A Number",null,null,"Percentage Difference"]
[]
[]
[]
[null,"Original Number",150,null,"Part Number",3,null,"Percent",0.1,null,"Number A",100]
[null,"New Number",100,null,"Total Number",30,null,"Original Number",150,null,"Number B",50]
[null,{"$f":"IF(C8<C9,\"Percentage Increase =\", \"Percent Decrease =\")","v":"Percent Decrease ="},{"$f":"ABS((C9-C8)/C8)","v":0.33333333333333331},null,"Percent =",{"$f":"F8/F9","v":0.1},null,"New Number =",{"$f":"I9*I8+I9","v":165},null,"Percent Difference =",{"$f":"ABS((L8-L9)/((L8+L9)/2))","v":0.66666666666666663}]
[null,{"$f":"IF(C8<C9,\"Change from \"& C8 & \" to \" & C9 &\" is a \" & TEXT(C10,\"0%\") & \" Increase\", \"Change from \"& C8 & \" to \" & C9 &\" is a \" & TEXT(C10,\"0%\") & \" Decrease\")","v":"Change from 150 to 100 is a 33% Decrease"},null,null,{"$f":"F8 & \" out of \" & F9 &\" is \" & TEXT(F10,\"0%\")","v":"3 out of 30 is 10%"},null,null,{"$f":"\"Add \"& TEXT(I8,\"0%\") & \" To \" & I9 & \" = \"&I10","v":"Add 10% To 150 = 165"},null,null,{"$f":"\"Difference between \"& L8 & \" and \" & L9 & \" = \"& TEXT(L10,\"0%\")","v":"Difference between 100 and 50 = 67%"}]
[null,null,null,null,null,null,null,{"$f":"I9 & \" Plus \" & TEXT(I8, \"0%\") & \" = \"&I10","v":"150 Plus 10% = 165"}]
[]
[null,"Percentage Greater or Less Than",null,null,"Part of Total Percentage (2)",null,null,"Subtract A Percentage From A Number",null,null,"Percentage of a Number"]
[]
[]
[]
[null,"Number A",10,null,"Part Number",25,null,"Percent",0.1,null,"Percent",0.3]
[null,"Number B",25,null,"Percentage",0.5,null,"Original Number",150,null,"Original Number",100]
[null,"Percent =",{"$f":"ABS((C18-C19)/C19)","v":0.6},null,"Total Number =",{"$f":"F18/F19","v":50},null,"New Number =",{"$f":"I19-(I19*I18)","v":135},null,"New Number =",{"$f":"L18*L19","v":30}]
[null,{"$f":"IF(C18<C19,C18 & \" is \" & TEXT(C20,\"0%\") &\" Less than \" &C19, C18 & \" is \" & TEXT(C20,\"0%\") &\" Greater than \" &C19)","v":"10 is 60% Less than 25"},null,null,{"$f":"F18 & \" is \" & TEXT(F19,\"0%\") &\" of \" &F20","v":"25 is 50% of 50"},null,null,{"$f":"\"Subtract \"& TEXT(I18,\"0%\") & \" From \" & I19 & \" = \"&I20","v":"Subtract 10% From 150 = 135"},null,null,{"$f":"TEXT(L18,\"0%\") & \" of \" & L19 &\" is \" &L20","v":"30% of 100 is 30"}]
[null,null,null,null,null,null,null,{"$f":"I19 & \" Minus \" & TEXT(I18,\"0%\") & \" = \"&I20","v":"150 Minus 10% = 135"}]
[]
[null,"Percentage Off (1)"]
[null,"Original Number",100]
[null,"Percentage Off",0.25]
[null,"New Number =",{"$f":"C25*((100-C26*100)/100)","v":75}]
[null,{"$f":"TEXT(C26,\"0%\") &\" off \" &C25 & \" is \" & C27","v":"25% off 100 is 75"}]
[]
[null,"Percentage Off (2)"]
[null,"Original Number",100]
[null,"New Number",25]
[null,"Percentage Off =",{"$f":"(100-((C32/C31)*100))/100","v":0.75}]
[null,{"$f":"\"From \" &C31 &\" To \" &C32 & \" is \" & TEXT(C33,\"0%\") &\" off \"","v":"From 100 To 25 is 75% off "}]

{"sheet":"Individual Percentage","index":12,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[[3,1,3,3]]}
[null,null,null,null,"INDIVIDUAL PERCENTAGE"]
[null,null,null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,"Individual Percentage of Total"]
[]
[]
[null,"Name","Value","Individual Percentage"]
[null,"Item 1",25,{"$f":"IF(C8=\"\",\"\",1-((C18-C8)/C18))","v":0.19841269841269837}]
[null,"Item 2",25,{"$f":"IF(C9=\"\",\"\",1-((C18-C9)/C18))","v":0.19841269841269837}]
[null,"Item 3",25,{"$f":"IF(C10=\"\",\"\",1-((C18-C10)/C18))","v":0.19841269841269837}]
[null,"Item 4",25,{"$f":"IF(C11=\"\",\"\",1-((C18-C11)/C18))","v":0.19841269841269837}]
[null,"Item 5",26,{"$f":"IF(C12=\"\",\"\",1-((C18-C12)/C18))","v":0.20634920634920639}]
[null,"DEMO","DEMO","DEMO"]
[null,"DEMO","DEMO","DEMO"]
[null,"DEMO","DEMO","DEMO"]
[null,"DEMO","DEMO","DEMO"]
[null,"DEMO","DEMO","DEMO"]
[null,"Total =",{"$f":"SUM(C8:C12)","v":126},{"$f":"SUM(D8:D12)","v":0.99999999999999989}]

{"sheet":"Percent EA","index":13,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":true,"merged":[[3,8,3,10],[8,4,8,6],[8,8,8,10],[18,1,18,2],[3,1,3,2],[13,1,13,2],[8,1,8,2],[3,4,3,6]]}
[null,null,null,null,"      Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,"PERCENTAGE (Engineers & Achitects)",null,null,null,"Return To Main Sheet"]
[]
[null,"Percent Free Area",null,null,"Space Negative Pressure",null,null,null,"Space Positive Pressure"]
[null,"Total Area (Sq. Ft)",100,null,"System Outside Air",8000,"CFM",null,"Total Exhaust Air",8000,"CFM"]
[null,"Free Area (Sq. Ft)",25,null,"Percent Negative Pressure",0.1,"Percent",null,"Percent Positive Pressure",0.1,"Percent"]
[null,"Percent Free Area =",{"$f":"1-((C5-C6)/C5)","v":0.25},null,"Required Exhaust Air = ",{"$f":"F5+(F5*F6)","v":8800},"CFM",null,"Required Outside Air = ",{"$f":"J5+(J5*J6)","v":8800},"CFM"]
[]
[null,"Percent Load Capacity",null,null,"Percent Negative Pressure",null,null,null,"Percent Positive Pressure"]
[null,"Full Load",100,null,"System Outside Air",8000,"CFM",null,"System Outside Air",1000,"CFM"]
[null,"Part Load",75,null,"System Exhaust Air",8800,"CFM",null,"System Exhaust Air",800,"CFM"]
[null,"Percent Capacity =",{"$f":"1-((C10-C11)/C10)","v":0.75},null,"Negative Pressure = ",{"$f":"(F10-F11)/F10","v":-0.1},"Percent",null,"Positive Pressure = ",{"$f":"(J10-J11)/J10","v":0.2},"Percent"]
[]
[null,"Window-To-Wall Ratio"]
[null,"Window Area (Sq. Ft)",50]
[null,"Total Area (Sq. Ft)",200]
[null,"Percent Capacity =",{"$f":"C15/C16","v":0.25}]
[]
[null,"Percent Load Capacity"]
[]
[]
[]
[null,"Full Load",100]
[null,"Operating Load",75]
[null,"Operating Load Capacity =",{"$f":"1-((C23-C24)/C23)","v":0.75}]

{"sheet":"GPM","index":14,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":true,"merged":[[20,1,20,7],[11,2,11,4],[11,6,11,8],[0,1,0,9],[5,2,5,4],[5,6,5,8],[3,2,3,8]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,null,"GPM CALCULATIONS"]
[]
[null,null,"Chilled Water GPM Calc.",null,null,null,"Hot Water GPM Calc."]
[]
[null,null,"Cooling Load (Tons)",120,"Tons",null,"Heating Load",50000,"Btu/hr"]
[null,null,"Water ∆T",10,"F",null,"Water ∆T",20,"F"]
[null,null,"GPM (Evaporator) =",{"$f":"(D8*24)/D9","v":288},"GPM",null,"GPM = ",{"$f":"H8/(500*H9)","v":5},"GPM"]
[]
[null,null,"Cooling Capacity Calc.",null,null,null,"Heating Capacity Calc."]
[]
[null,null,"Water Flow (GPM)",288,"GPM",null,"Water Flow (GPM)",288,"GPM"]
[null,null,"Water ∆T",10,"F",null,"Water ∆T",20,"F"]
[null,null,"Cooling Capacity (Btu/hr) =",{"$f":"500*D14*D15","v":1440000},"Btu/hr",null,"Heating Capacity (Btu/hr) =",{"$f":"500*H14*H15","v":2880000},"Btu/hr"]
[null,null,"Cooling Capacity (Tons) =",{"$f":"D16/12000","v":120},"Tons",null,"Heating Capacity (MBH) =",{"$f":"H16/1000","v":2880},"MBH"]

{"sheet":"Demo","index":15,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,1,0,7],[7,2,7,6]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[]
[null,null,null,null,"Return To Main Sheet"]
[]
[null,null,null,null,"This Sheet Is Not Available In The DEMO Version."]
[null,null,null,null,"Get The Full Version To Use These Calculations."]
[]
[null,null,"www.HVACnotebook.com"]

{"sheet":"Fan Law","index":16,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[[3,1,10,1],[12,1,19,1],[1,9,1,10],[1,6,1,7],[0,1,0,10],[12,3,12,4],[12,6,12,7],[12,9,12,10],[3,3,3,4],[3,6,3,7],[3,9,3,10],[40,0,40,10],[21,3,21,4],[21,6,21,7],[21,9,21,10],[30,3,30,4],[30,6,30,7],[30,9,30,10],[38,0,38,10],[39,0,39,10],[21,1,28,1],[30,1,37,1]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"FAN LAWS",null,null,"Return To Main Sheet"]
[]
[null,"New BHP",null,"New BHP From Change in CFM",null,null,"New BHP From Change in RPM",null,null,"New BHP From Change in SP"]
[]
[]
[]
[null,null,null,"CFM1",10000,null,"RPM1",850,null,"SP1",2.4]
[null,null,null,"BHP1",10,null,"BHP1",10,null,"BHP1",10]
[null,null,null,"CFM2",7000,null,"RPM2",800,null,"SP2",2]
[null,null,null,"BHP2 =",{"$f":"((E10/E8)^3)*E9","v":3.4299999999999993},null,"BHP2 =",{"$f":"((H10/H8)^3)*H9","v":8.3370649297781405},null,"BHP2 =",{"$f":"((K10/K8)^1.5)*K9","v":7.607257743127307}]
[]
[null,"New CFM",null,"New CFM From Change in BHP",null,null,"New CFM From Change in RPM",null,null,"New CFM From Change in SP"]
[]
[]
[]
[null,null,null,"BHP1",10,null,"RPM1",850,null,"SP1",2.4]
[null,null,null,"CFM1",10000,null,"CFM1",10000,null,"CFM1",10000]
[null,null,null,"BHP2",3.43,null,"RPM2",680,null,"SP2",1.54]
[null,null,null,"CFM2 =",{"$f":"((E19/E17)^(1/3))*E18","v":7000.0000000000009},null,"CFM2 =",{"$f":"(H19/H17)*H18","v":8000},null,"CFM2 =",{"$f":"((K19/K17)^(1/2))*K18","v":8010.4098937986109}]
[]
[null,"New SP",null,"New SP From Change in CFM",null,null,"New SP From Change in RPM",null,null,"New SP From Change in BHP"]
[]
[]
[]
[null,null,null,"CFM1","DEMO",null,"RPM1","DEMO",null,"BHP1","DEMO"]
[null,null,null,"SP1","DEMO",null,"SP1","DEMO",null,"SP1","DEMO"]
[null,null,null,"CFM2","DEMO",null,"RPM2","DEMO",null,"BHP2","DEMO"]
[null,null,null,"SP2 =","N/A",null,"SP2 =","N/A",null,"SP2 =","N/A"]
[]
[null,"New RPM",null,"New RPM From Change in CFM",null,null,"New RPM From Change in SP",null,null,"New RPM From Change in BHP"]
[]
[]
[]
[null,null,null,"CFM1","DEMO",null,"SP1","DEMO",null,"BHP1","DEMO"]
[null,null,null,"RPM1","DEMO",null,"RPM1","DEMO",null,"RPM1","DEMO"]
[null,null,null,"CFM2","DEMO",null,"SP2","DEMO",null,"BHP2","DEMO"]
[null,null,null,"RPM2 =","N/A",null,"RPM2 =","N/A",null,"RPM2 =","N/A"]
["Get the Full Version of \"M1-QuickCalcs-HVAC.xlsm\" to use all features."]
["The above calculations are also available in CalcSheet format: \"EQ5 - Fan Laws.xlsx\""]
["Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Airflow","index":17,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[[0,1,0,5],[16,2,16,4],[3,1,3,5],[6,2,7,2],[10,2,10,4],[11,2,11,4],[15,2,15,4]]}
[null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,"AIRFLOW CALCULATION"]
[]
[null,null,"Room Area",170,"SF"]
[null,null,"Height",9,"ft"]
[null,null,null,6,"Inches"]
[null,null,"Room Volume = ",{"$f":"D6*(D7+D8/12)","v":1615},"CF"]
[]
[null,null,"Airflow Calc. Based on CFM/SF"]
[]
[null,null,"Design Flow/Area",1,"CFM/SF"]
[null,null,"Design Airflow = ",{"$f":"D13*D6","v":170},"CFM "]
[]
[null,null,"Airflow Calc. Based on ACH"]
[]
[null,null,"Design ACH",6,"ACH"]
[null,null,"Design Airflow = ",{"$f":"(D18/60)*D9","v":161.5},"CFM"]
[]
[]
[null,null,null,"The above calculations are also available in CalcSheet format: \"A1 - Smoke Purge Airflow Calculation.xlsx\""]
[null,null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Pressurization","index":18,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,7,1,9],[3,2,3,4],[3,6,3,8],[9,2,9,4],[9,6,9,8]]}
[null,null,null,null,null,"Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,"PRESSURIZATION",null,"Return To Main Sheet"]
[]
[null,null,"Negative Pressurization",null,null,null,"Positive Pressurization"]
[null,null,"Supply Air",8000,"CFM",null,"Total Exhaust Air",8000,"CFM"]
[null,null,"Percent Negative Pressure",0.1,"Percent",null,"Percent Positive Pressure",0.1,"Percent"]
[null,null,"Required Exhaust Air = ",{"$f":"D5+(D5*D6)","v":8800},"CFM",null,"Required Outside Air = ",{"$f":"H5+(H5*H6)","v":8800},"CFM"]
[]
[]
[null,null,"Percent Negative Pressurization",null,null,null,"Percent Positive Pressurization"]
[null,null,"Supply Air",8000,"CFM",null,"Outside Air",1000,"CFM"]
[null,null,"Exhaust Air",8800,"CFM",null,"Exhaust Air",800,"CFM"]
[null,null,"Percent Negative Pressure = ",{"$f":"(D11-D12)/D11","v":-0.1},"Percent",null,"Percent Positive Pressure = ",{"$f":"(H11-H12)/H11","v":0.2},"Percent"]

{"sheet":"Louver","index":19,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[[1,6,1,7],[0,1,0,7],[13,2,13,3],[3,5,3,7],[6,1,7,1],[9,1,10,1],[3,1,3,3]]}
[null,"       Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,"LOUVER SIZING",null,"Return To Main Sheet"]
[]
[null,"Louver Size Based on Velocity & Free Area",null,null,null,"Air Velocity Based on Airflow & Free Area"]
[null,"Airflow",40000,"CFM",null,"Airflow",40000,"CFM"]
[null,"Face Velocity",500,"FPM",null,"Louver Face Area",100,"Sq. Ft."]
[null,"Required Free Area =",{"$f":"C5/C6","v":80},"Sq. Ft.",null,"Louver Free Area (%)",0.5,"Design"]
[null,null,{"$f":"C7*144","v":11520},"Sq. Inches",null,"Resulted Free Area =",{"$f":"G6*G7","v":50},"Sq. Ft."]
[null,"Louver Free Area (%)",0.5,"Design",null,"Resulted Air Velocity =",{"$f":"G5/G8","v":800},"FPM"]
[null,"Louver Face (Total) Area =",{"$f":"C7/C9","v":160},"Sq. Ft."]
[null,null,{"$f":"C10*144","v":23040},"Sq. Inches"]
[null,"Louver Width",46,"Inches"]
[null,"Louver Height =",{"$f":"INT(C11/C12)","v":500},"Inches"]
[null,"Required Louver Face Area = ",{"$f":"IF(C12=\"\", \"\", IF(C12<12,C12&\"\"\"\", INT(C12/12) &\"' - \"&MOD(C12,12)&\"\"\"\"))&\" W x \"&IF(C13=\"\", \"\", IF(C13<12,C13&\"\"\"\", INT(C13/12) &\"' - \"&MOD(C13,12)&\"\"\"\"))&\" H\"","v":"3' - 10\" W x 41' - 8\" H"}]
[]
[]
[null,null,null,null,"The above calculations are also available in CalcSheet format: \"A2 - Louver Sizing Using FPM.xlsx\""]
[null,null,null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Message","index":20,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"MESSAGE"]
[]
[null,null,"You MUST enable macros to use the calculation spreadsheets.  Please click the \"Enable Content\" button located below the Ribbon (Excel 2010 & 2013) to enable macros.  Or close this file and open it again under the enable macros mode."]
[]
[null,null,"This is a FREE Version of the \"QuickCalcs-HVAC.xlsm\" and will expire on November 1, 2018.  You will not be able to print or save any data in this file.  For a Full Version (printable & saveable) without the 10 second screen delay, see \"QuickCalcs-HVAC.xlsm\" at:"]
[null,null,"www.HVACnotebook.com"]
[]
[null,null,"If this file has expired (after 11/1/2018), please visit our website for another free download."]

{"sheet":"Disclaimer","index":21,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[3,2,3,4],[9,2,9,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4]]}
[]
[null,null,null,null,"Return To Main Sheet"]
[]
[null,null,"USER GUIDE"]
[null,null,"1)","Enter (Replace) value in yellow cells.  Results will automatically be calculated in grey cells with final answer in blue cells."]
[null,null,"2)","User must Enable Marcos for the spreadsheets to work properly."]
[null,null,"3)","These spreadsheets can not be saved or printed, and will expire on November 1, 2018. "]
[null,null,"4)","Please read the below Disclaimer prior to use.  Click the above \"Return To Main Sheet\" button to start using our spreadsheets."]
[null,null,"5)","Visit our website at www.HVACnotebook.com for more products."]
[null,null,"DISCLAIMER"]
[null,null,"1)","The intend of these spreadsheets is to reduce tedious & repetitive calculations.  It is assumed that the user is familiar with the formulas applied and can perform these calculations on his/her own without these spreadsheets.  User is responsible to verify the results and correctly use the results from these spreadsheets.  We are NOT responsible for any errors in these spreadsheets."]
[null,null,"2)","We make no guarantees about the quality of our Spreadsheets and is not responsible for any claims, losses, damages, costs, or other obligations arising from use of our products or materials from our website. We also denies any responsibility for the quality and accuracy of the information presented on our spreadsheets and/or website.  Our website and all materials contained on it are distributed and transmitted “as is” without warranties of any kind, either express or implied.  "]
[null,null,"3)","We are not responsible for any special, indirect, incidental or consequential damages (regardless or whether they were foreseeable) that may arise from the use of, or the inability to use, our products and/or the materials contained on our website."]
[null,null,"4)","Any material downloaded from our website is done at your own discretion and risk. You will be solely responsible for any damage to your computer system or other device or loss of data that results from the download or use of any such material."]

{"sheet":"Electrical","index":22,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,1,0,22],[1,18,1,19],[3,1,3,22],[6,2,6,6],[6,7,6,11],[6,12,6,16],[6,17,6,21]]}
[null,"       Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Return To Main Sheet"]
[]
[null,"ELECTRICAL: OHM'S LAW"]
[null,null,"V = Voltage (Volts)",null,"P = Power (Watts)",null,null,null,"I = Current (Amps)",null,"R = Resistance (Ohms)"]
[]
[null,null,"FIND VOLTAGE",null,null,null,null,"FIND CURRENT",null,null,null,null,"FIND POWER",null,null,null,null,"FIND RESISTANCE"]
[]
[]
[]
[null,null,null,"Power (P)",34,"Watts",null,null,"Voltage (V)",34,"Volts",null,null,"Current (I)",5,"Amps",null,null,"Voltage (V)",34,"Volts"]
[null,null,null,"Current (I)",5,"Amps",null,null,"Resistance (R)",5,"Ohms",null,null,"Resistance (R)",5,"Ohms",null,null,"Current (I)",5,"Amps"]
[null,null,null,"Voltage (V) =",{"$f":"E11/E12","v":6.8},"Volts",null,null,"Current (I) =",{"$f":"J11/J12","v":6.8},"Amps",null,null,"Power (P) =",{"$f":"O11*O11*O12","v":125},"Watts",null,null,"Resistance (R) =",{"$f":"T11/T12","v":6.8},"Ohms"]
[]
[]
[]
[null,null,null,"Current (I)",5,"Amps",null,null,"Power (P)",5,"Watts",null,null,"Voltage (V)",5,"Volts",null,null,"Voltage (V)",5,"Volts"]
[null,null,null,"Resistance (R)",6,"Ohms",null,null,"Voltage (V)",6,"Volts",null,null,"Current (I)",6,"Amps",null,null,"Power (P)",6,"Watts"]
[null,null,null,"Voltage (V) =",{"$f":"E17*E18","v":30},"Volts",null,null,"Current (I) =",{"$f":"J17/J18","v":0.83333333333333337},"Amps",null,null,"Power (P) =",{"$f":"O17*O18","v":30},"Watts",null,null,"Resistance (R) =",{"$f":"(T17*T17)/T18","v":4.166666666666667},"Ohms"]
[]
[]
[]
[null,null,null,"Power (P)","DEMO","Watts",null,null,"Power (P)","DEMO","Watts",null,null,"Voltage (V)","DEMO","Volts",null,null,"Power (P)","DEMO","Watts"]
[null,null,null,"Resistance (R)","DEMO","Ohms",null,null,"Resistance (R)","DEMO","Ohms",null,null,"Resistance (R)","DEMO","Ohms",null,null,"Current (I)","DEMO","Amps"]
[null,null,null,"Voltage (V) =","N/A","Volts",null,null,"Current (I) =","N/A","Amps",null,null,"Power (P) =","N/A","Watts",null,null,"Resistance (R) =","N/A","Ohms"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Get the Full Version of \"M1-QuickCalcs-HVAC.xlsm\" to use all features."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Chiller","index":23,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[[13,5,13,7],[0,1,0,7],[3,5,3,7],[4,1,4,3],[8,5,8,7],[11,1,11,3]]}
[null,"       Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,null,null,null,"Return To Main Sheet"]
[null,null,null,null,"CHILLER - (ELECTRIC)"]
[null,null,null,null,null,"GIVEN CHILLER COP"]
[null,"CHILLED WATER FLOW",null,null,null,"COP =",4.2,"From Manufacturer"]
[null,"Cooling Load",120,"Tons",null,"EER =",{"$f":"G5*3.412","v":14.330400000000001},"EER = COP x 3.412"]
[null,"CHW Supply Temperature",45,"F",null,"kW/Ton =",{"$f":"3.516/G5","v":0.83714285714285708},"kW/Ton = 3.516 / COP"]
[null,"CHW Return Temperature",55,"F"]
[null,"Required CHW Flow (GPM) =",{"$f":"C6*12000/(500*(C8-C7))","v":288},"GPM",null,"GIVEN CHILLER EER"]
[null,null,null,null,null,"EER =",14.33,"From Manufacturer"]
[null,null,null,null,null,"COP =",{"$f":"G10/3.412","v":4.1998827667057448},"COP = EER / 3.412"]
[null,"CONDENSER WATER FLOW",null,null,null,"kW/Ton =",{"$f":"3.516/G11","v":0.83716622470341928},"kW/Ton = 3.516 / COP"]
[null,"Cooling Load","DEMO","Tons"]
[null,"CW Supply Temperature","DEMO","F",null,"GIVEN CHILLER KW/TON"]
[null,"CW Return Temperature","DEMO","F",null,"kW/Ton =",0.83699999999999997,"From Manufacturer"]
[null,"Required CW Flow (GPM) =","DEMO","GPM",null,"EER =",{"$f":"12/G15","v":14.336917562724015},"EER = 12 / kW/Ton"]
[null,null,null,null,null,"COP =",{"$f":"G16/3.412","v":4.2019101883716337},"COP = EER / 3.412"]
[null,null,null,null,"Get the Full Version of \"M1-QuickCalcs-HVAC.xlsm\" to use all features."]
[null,null,null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"100 OA","index":24,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[[20,0,20,6],[21,0,21,6],[22,0,22,6],[0,2,0,4],[2,2,2,4],[3,2,3,4],[10,2,10,4],[1,4,1,5]]}
[null,null,"       Please read the User Guide and Disclaimer prior to use."]
[null,null,null,null,"Return To Main Sheet"]
[null,null,"100% OUTSIDE AIR UNIT"]
[null,null,"HEATING COIL LOAD ESTIMATE"]
[null,null,"Outside Air Temperature Dry Bulb",11,"F"]
[null,null,"Heating Coil Leaving Air Temperature Dry Bulb",95,"F"]
[null,null,"Unit Airflow",5000,"CFM"]
[null,null,"Total Btu/hr =",{"$f":"1.08*D7*(D6-D5)","v":453600},"Btu/hr"]
[null,null,"Total Heating Load =",{"$f":"D8/1000","v":453.6},"MBH"]
[]
[null,null,"COOLING COIL LOAD ESTIMATE"]
[null,null,"Outside Air Temperature Dry Bulb","DEMO","F"]
[null,null,"Outside Air Temperature Wet Bulb","DEMO","F"]
[null,null,"Outside Air Temperature Enthalpy","DEMO"]
[null,null,"Cooling Coil Leaving Air Temperature Dry Bulb","DEMO","F"]
[null,null,"Cooling Coil Leaving Air Temperature Wet Bulb","DEMO","F"]
[null,null,"Cooling Coil Leaving Air Temperature Enthalpy","DEMO"]
[null,null,"Unit Airflow","DEMO","CFM"]
[null,null,"Total Btu/hr =","DEMO","Btu/hr"]
[null,null,"Total Cooling Load =","N/A","Tons"]
["Get the Full Version of \"M1-QuickCalcs-HVAC.xlsm\" to use all features."]
["The above calculations are also available in CalcSheet format: \"L8 - 100% Outside Air Unit Coils Sizing.xlsx\""]
["Contact us for more information. Email: hvacnotebook@yahoo.com"]

{"sheet":"Pipe Cost","index":25,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,2,0,10],[5,2,5,10],[27,3,28,10],[29,3,30,10],[1,13,1,14],[1,4,1,8],[2,4,2,8],[6,13,6,17],[7,13,7,17],[23,2,23,10],[24,2,24,3],[25,3,26,10],[21,2,21,10],[22,2,22,10]]}
[null,null,"       Please read the User Guide and Disclaimer prior to use."]
[null,null,null,"Project Title:","Chilled Water System Replacement at 123 Broadway",null,null,null,null,"Date:","2015-09-25",null,null,"Return To Main Sheet"]
[null,null,null,"Note:","Schedule 40 Piping Cost Estimate",null,null,null,null,"Prepared:","T.K."]
[]
[]
[null,null,"Piping Cost Estimate"]
[null,null,"Item#","Tag","Item","Quantity","Unit","Pipe Unit Price","Item Unit Price","Item Total","Assumption / Remarks",null,null,"Unit Price Table (Per LF)"]
[null,null,1,"A-B","4\" dia. Sch 40 Welded",10,"LF",{"$f":"IF(E8=\"\",\"\",IF(ISERROR(VLOOKUP(E8,$N$10:$R$28,5,FALSE)), \"\", VLOOKUP(E8,$N$10:$R$28,5,FALSE)))","v":36.220000000000006},null,{"$f":"IF(E8=\"\",\"\",IF(H8=\"\",F8*I8,F8*H8+F8*I8))","v":362.20000000000005},"Main from header",null,null,"Welded, Sch 40 Black Steel with yoke & roll hanger, 10' O.C."]
[null,null,2,"A-B","4\" Valve",1,"EA","",200,200,null,null,null,"Item","Materials","Labor","Equipment","Total"]
[null,null,3,"B-C","4\" dia. Sch 40 Welded",20,"LF",36.220000000000006,null,724.40000000000009,"Segment B-C",null,null,"1\" dia. Sch 40 Welded",3.7,7.25,0.6,{"$f":"O10+P10+Q10","v":11.549999999999999}]
[null,null,4,"C-D","3\" dia. Sch 40 Welded",2,"LF",29.459999999999997,null,58.919999999999995,null,null,null,"1-1/4\" dia. Sch 40 Welded",4.93,8,0.67,{"$f":"O11+P11+Q11","v":13.6}]
[null,null,5,"D-E","3\" Valve",1,"EA","",150,150,"Isolation Valves",null,null,"1-1/2\" dia. Sch 40 Welded",5.65,8.85,0.74,15.24]
[null,null,6,"E-F","3\" dia. Sch 40 Welded",6,"LF",29.459999999999997,null,176.76,null,null,null,"2\" dia. Sch 40 Welded",7.4,11,0.92,19.32]
[null,null,7,"F-G","2-1/2\" dia. Sch 40 Welded",20,"LF",25.290000000000003,null,505.80000000000007,null,null,null,"2-1/2\" dia. Sch 40 Welded",9.8000000000000007,14.3,1.19,25.290000000000003]
[null,null,8,"G-H","2\" dia. Sch 40 Welded",10,"LF",19.32,null,193.2,null,null,null,"3\" dia. Sch 40 Welded",12.5,15.65,1.31,29.459999999999997]
[null,null,9,null,null,null,null,"",null,"",null,null,null,"3-1/2\" dia. Sch 40 Welded",13.9,17.25,1.44,32.589999999999996]
[null,null,10,null,null,null,null,"",null,{"$f":"IF(E17=\"\",\"\",F17*H17+F17*I17)","v":""},null,null,null,"4\" dia. Sch 40 Welded",16.5,18.2,1.52,36.220000000000006]
[null,null,null,null,null,null,null,null,"Subtotal =",{"$f":"SUM(J8:J17)","v":2371.2800000000002},null,null,null,"5\" dia. Sch 40 Welded",24,21,1.76,46.76]
[null,null,null,null,null,null,null,"Allowance:",0.25,{"$f":"J18*I19","v":592.82000000000005},null,null,null,"6\" dia. Sch 40 Welded",30,29,1.56,60.56]
[null,null,null,null,null,null,null,null,"GRAND TOTAL =",{"$f":"J18+J19","v":2964.1000000000004},null,null,null,"8\" dia. Sch 40 Welded",47,36,1.94,84.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10\" dia. Sch 40 Welded",88,43.5,2.34,{"$f":"O21+P21+Q21","v":133.84}]
[null,null,"The above calculations are also available in CalcSheet format: \"P1 - Piping Cost Estimate.xlsx\"",null,null,null,null,null,null,null,null,null,null,"12\" dia. Sch 40 Welded",122,55,2.96,179.96]
[null,null,"We can custom create a Piping Cost Estimate sheet for you. (Copper, Stainless Steel, Etc.)",null,null,null,null,null,null,null,null,null,null,"14\" dia. Sch 40 Welded",85,69.5,3.74,158.24]
[null,null,"Contact us for more information. Email: hvacnotebook@yahoo.com",null,null,null,null,null,null,null,null,null,null,"16\" dia. Sch 40 Welded",114,80.5,4.32,198.82]
[null,null,"User Guide",null,null,null,null,null,null,null,null,null,null,"18\" dia. Sch 40 Welded",120,95,5.0999999999999996,220.1]
[null,null,"1)","To enter pipe in Item column, pick pipe diameter from pull-down list than enter length in Quantity column.  Pipe Unit Price (Data from Unit Price Table) and Item Total will automatically appear.",null,null,null,null,null,null,null,null,null,"20\" dia. Sch 40 Welded",146,116,6.25,268.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"24\" Dia. Sch 40 Pipe",186,131,7,324]
[null,null,"2)","To enter a non-pipe item, type a name in the Item column and than enter its unit price in Item Unit Price column. Item Total will automatically appear.",null,null,null,null,null,null,null,null,null,"Add Others…",null,null,null,0]
[]
[null,null,"3)","If both pipe size is selected and Item Unit Price is entered, Item Total will be highlighted red to indicate an error.  Either pipe or item can be on one line.  To fix, delete value in Item Unit Price or type an item in Item column."]